package com.atcc.test.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Options.FlushCachePolicy;

import com.atcc.test.domain.UserInfo;

import org.apache.ibatis.annotations.*;

@Mapper
public interface UserInfoMapper {
	
	@Select("select *from userinfo where phoneNumber = #{phoneNumber}")
	@Results({
		@Result(column="name",property="name"),
		@Result(column="phoneNumber",property="phoneNumber"),
		@Result(column="password",property="password"),
	})
	@Options(useCache=true,flushCache=FlushCachePolicy.FALSE)
	UserInfo getUserInfoByPhoneNumber(String phoneNumber);

}
